/**
 * @description GoodsPhoto 装修项目信息表
 * @author LI
 */

const seq = require('../sequelize')
const { STRING, INTEGER, DECIMAL } =require('../types')

// DecoratItems DecoratItem 写入到数据库时为 DecoratItems
const DecoratItemInfo = seq.define('decoratItemInfo', {
  itemNumber: {
    type: INTEGER,
    allowNull: false,
    comment: '项目数量'
  },
  itemPrice: {
    type: DECIMAL,
    allowNull: false,
    comment: '人工辅料/单价'
  },
  decoratItemId: {
    type: INTEGER,
    allowNull: false,
    comment: '对应装修项目 id'
  },
  goodsInfoId: {
    type: INTEGER,
    allowNull: false,
    comment: '对应商品信息里面的 id'
  },
  remark: {
    type: STRING,
    comment: '要求，备注'
  },
  reserve: {
    type: STRING,
    comment: '保留字段'
  }
},
{
  comment: '装修项目信息表',
})

module.exports = DecoratItemInfo
